package com.example.manage_dzensaas.pojo.entity.db2;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 站点实体卡卡片集
 * @TableName welfare-mall.site_card_set
 */
@TableName(value ="site_card_set")
@Data
public class SiteCardSet implements Serializable {
    /**
     * 卡片集ID
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 实体卡ID
     */
    @TableField(value = "card_id")
    private Long cardId;

    /**
     * 卡号
     */
    @TableField(value = "card_number")
    private String cardNumber;

    /**
     * 兑换码(系统生成10为字母加数字)卡密
     */
    @TableField(value = "exchange_code")
    private String exchangeCode;

    /**
     * 面值
     */
    @TableField(value = "face_value")
    private BigDecimal faceValue;

    /**
     * 绑定用户ID
     */
    @TableField(value = "consumer_id")
    private Long consumerId;

    /**
     * 有效期结束时间
     */
    @TableField(value = "validity_end_time")
    private Date validityEndTime;

    /**
     * 是否过期0否1是
     */
    @TableField(value = "is_overdue")
    private Integer isOverdue;

    /**
     * 是否使用0否1是
     */
    @TableField(value = "is_use")
    private Integer isUse;

    /**
     * 公司名称
     */
    @TableField(value = "company_name")
    private String companyName;

    /**
     * 激活时间
     */
    @TableField(value = "active_time")
    private Date activeTime;

    /**
     * 暂缓使用
     */
    @TableField(value = "suspend_state")
    private Integer suspendState;

    /**
     * 站点ID
     */
    @TableField(value = "site_id")
    private Long siteId;

    /**
     * 卡卷余额
     */
    @TableField(value = "balance")
    private BigDecimal balance;

    /**
     * 销售单ID
     */
    @TableField(value = "sales_order_id")
    private Long salesOrderId;

    /**
     * 绑定时间
     */
    @TableField(value = "binding_time")
    private Date bindingTime;

    /**
     * 卡卷类型: 0=待启用、1=充值、2=独立积分
     */
    @TableField(value = "card_type")
    private Integer cardType;

    /**
     * 排序
     */
    @TableField(value = "`rank`")
    private Integer rank;

    /**
     * 是否异常卡
     */
    @TableField(value = "is_ex")
    private Integer isEx;

    /**
     * 
     */
    @TableField(value = "oid")
    private Integer oid;

    /**
     * 状态1有效0无效 
     */
    @TableField(value = "`status`")
    private Integer status;

    /**
     * 是否删除0否1是
     */
    @TableField(value = "dr")
    private Integer dr;

    /**
     * 创建时间
     */
    @TableField(value = "create_time")
    private Date createTime;

    /**
     * 修改时间
     */
    @TableField(value = "update_time")
    private Date updateTime;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}